USE TravelexForwardContract
---------------------------------------------------------------
GO
IF OBJECT_ID('h_sp_find_exist_records','P') IS NOT NULL
DROP PROCEDURE h_sp_find_exist_records
-------------- ------------------------------------------------
GO
CREATE PROCEDURE h_sp_find_exist_records
	@in_logcialNumber varchar(50), @in_counterparty varchar(50)
AS
BEGIN	
	SELECT  COUNT(*)
			FROM TPayment 
			WHERE LogicalNumber=@in_logcialNumber AND Counterparty=@in_counterparty	
		
END